package com.example.demo.mapper;
import com.example.demo.entity.Student;
import com.example.demo.entity.User;
import com.example.demo.entity.Book_instrument;
import com.github.pagehelper.Page;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface Book_instrumentMapper {
    @Select("SELECT * FROM book_instrument WHERE s_id = #{s_id} AND i_id=#{i_id}")
    Book_instrument queryByS_idAndI_id(@Param("s_id") String s_id,
                          @Param("i_id") String i_id);

    @Select("SELECT * FROM book_instrument WHERE i_id = #{i_id}")
    List<Book_instrument> queryPByI_id(@Param("i_id") String i_id);


}
